While it is certainly possible to day trip from Saint Petersburg, there are a couple options for lodging in Rurik's capital. Volkhov to the south also has a good number of hotels.
Staraya Ladoga